// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   change_ok.java

package logistics.file;

import include.get_sql.getInsertSql;
import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import include.operateDB.CdefineUpdate;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;
import validata.ValidataTag;

public class change_ok extends HttpServlet
{

	public change_ok()
	{
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		javax.servlet.ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			nseer_db_backup1 logistics_db = new nseer_db_backup1(dbApplication);
			if (logistics_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				counter count = new counter(dbApplication);
				ValidataTag vt = new ValidataTag();
				getInsertSql getInsertSql = new getInsertSql();
				ResultSet rset = null;
				String id = request.getParameter("id");
				String logisticser = request.getParameter("logisticser");
				String logisticser_ID = request.getParameter("logisticser_ID");
				String provider_ID = request.getParameter("provider_ID");
				String provider_name = request.getParameter("provider_name");
				String provider_address = request.getParameter("provider_address");
				String type = request.getParameter("type");
				String provider_class = request.getParameter("class");
				String used_provider_name = request.getParameter("used_provider_name");
				String provider_bank = request.getParameter("provider_bank");
				String provider_account = request.getParameter("provider_account");
				String provider_web = request.getParameter("provider_web");
				String provider_tel1 = request.getParameter("provider_tel1");
				String provider_fax = request.getParameter("provider_fax");
				String provider_postcode = request.getParameter("provider_postcode");
				String contact_person1 = request.getParameter("contact_person1");
				String contact_person1_department = request.getParameter("contact_person1_department");
				String contact_person1_duty = request.getParameter("contact_person1_duty");
				String contact_person1_sex = request.getParameter("contact_person1_sex");
				String contact_person1_office_tel = request.getParameter("contact_person1_office_tel");
				String contact_person1_home_tel = request.getParameter("contact_person1_home_tel");
				String contact_person1_mobile = request.getParameter("contact_person1_mobile");
				String contact_person1_email = request.getParameter("contact_person1_email");
				String contact_person2 = request.getParameter("contact_person2");
				String contact_person2_department = request.getParameter("contact_person2_department");
				String contact_person2_duty = request.getParameter("contact_person2_duty");
				String contact_person2_sex = request.getParameter("contact_person2_sex");
				String contact_person2_office_tel = request.getParameter("contact_person2_office_tel");
				String contact_person2_home_tel = request.getParameter("contact_person2_home_tel");
				String contact_person2_mobile = request.getParameter("contact_person2_mobile");
				String contact_person2_email = request.getParameter("contact_person2_email");
				String changer_ID = request.getParameter("changer_ID");
				String changer = request.getParameter("changer");
				String change_time = request.getParameter("change_time");
				String lately_change_time = request.getParameter("lately_change_time");
				String file_change_amount = request.getParameter("file_change_amount");
				int change_amount = Integer.parseInt(file_change_amount) + 1;
				String bodyc = new String(request.getParameter("invoice_info").getBytes("UTF-8"), "UTF-8");
				String invoice_info = exchange.toHtml(bodyc);
				String bodya = new String(request.getParameter("demand_products").getBytes("UTF-8"), "UTF-8");
				String demand_products = exchange.toHtml(bodya);
				String bodyb = new String(request.getParameter("recommend_products").getBytes("UTF-8"), "UTF-8");
				String recommend_products = exchange.toHtml(bodyb);
				String column_group = getInsertSql.sql((String)dbSession.getAttribute("unit_db_name"), "logistics_file");
				if (vt.validata((String)dbSession.getAttribute("unit_db_name"), "logistics_file", "provider_ID", provider_ID, "check_tag").equals("1"))
				{
					try
					{
						String fileKind_chain = request.getParameter("fileKind_chain");
						String chain_id = Divide1.getId(fileKind_chain);
						String chain_name = Divide1.getName(fileKind_chain);
						String sqll = (new StringBuilder("insert into logistics_file_dig(")).append(column_group).append(") select ").append(column_group).append(" from logistics_file where id='").append(id).append("'").toString();
						logistics_db.executeUpdate(sqll);
						String sql = (new StringBuilder("update logistics_file set chain_id='")).append(chain_id).append("',chain_name='").append(chain_name).append("',provider_name='").append(provider_name).append("',provider_address='").append(provider_address).append("',provider_class='").append(provider_class).append("',type='").append(type).append("',provider_bank='").append(provider_bank).append("',provider_account='").append(provider_account).append("',provider_web='").append(provider_web).append("',provider_tel1='").append(provider_tel1).append("',provider_fax='").append(provider_fax).append("',provider_postcode='").append(provider_postcode).append("',used_provider_name='").append(used_provider_name).append("',contact_person1='").append(contact_person1).append("',contact_person1_department='").append(contact_person1_department).append("',contact_person1_duty='").append(contact_person1_duty).append("',contact_person1_sex='").append(contact_person1_sex).append("',contact_person1_office_tel='").append(contact_person1_office_tel).append("',contact_person1_home_tel='").append(contact_person1_home_tel).append("',contact_person1_mobile='").append(contact_person1_mobile).append("',contact_person1_email='").append(contact_person1_email).append("',contact_person2='").append(contact_person2).append("',contact_person2_department='").append(contact_person2_department).append("',contact_person2_duty='").append(contact_person2_duty).append("',contact_person2_sex='").append(contact_person2_sex).append("',contact_person2_office_tel='").append(contact_person2_office_tel).append("',contact_person2_home_tel='").append(contact_person2_home_tel).append("',contact_person2_mobile='").append(contact_person2_mobile).append("',contact_person2_email='").append(contact_person2_email).append("',changer_ID='").append(changer_ID).append("',changer='").append(changer).append("',invoice_info='").append(invoice_info).append("',demand_products='").append(demand_products).append("',recommend_products='").append(recommend_products).append("',change_time='").append(change_time).append("',lately_change_time='").append(lately_change_time).append("',file_change_amount='").append(change_amount).append("',logisticser='").append(logisticser).append("',logisticser_ID='").append(logisticser_ID).append("',check_tag='0' where provider_ID='").append(provider_ID).append("'").toString();
						logistics_db.executeUpdate(sql);
						CdefineUpdate CdefineUpdate = new CdefineUpdate();
						sql = CdefineUpdate.update("logistics_file", "provider_ID", provider_ID, request);
						logistics_db.executeUpdate(sql);
						sql = (new StringBuilder("delete from logistics_workflow where object_id='")).append(provider_ID).append("'").toString();
						logistics_db.executeUpdate(sql);
						List rsList = new ArrayList();
						String elem[] = new String[3];
						sql = "select id,describe1,describe2 from logistics_config_workflow where type_id='01'";
						for (rset = logistics_db.executeQuery(sql); rset.next(); rsList.add(elem))
						{
							elem = new String[3];
							elem[0] = rset.getString("id");
							elem[1] = rset.getString("describe1");
							elem[2] = rset.getString("describe2");
						}

						if (rsList.size() == 0)
						{
							sql = (new StringBuilder("update logistics_file set check_tag='1' where provider_ID='")).append(provider_ID).append("'").toString();
							logistics_db.executeUpdate(sql);
						} else
						{
							for (Iterator ite = rsList.iterator(); ite.hasNext(); logistics_db.executeUpdate(sql))
							{
								elem = (String[])ite.next();
								sql = (new StringBuilder("insert into logistics_workflow(config_id,object_ID,describe1,describe2) values ('")).append(elem[0]).append("','").append(provider_ID).append("','").append(elem[1]).append("','").append(elem[2]).append("')").toString();
							}

						}
					}
					catch (Exception ex)
					{
						ex.printStackTrace();
					}
					response.sendRedirect((new StringBuilder("logistics/file/change_choose_attachment.jsp?provider_ID=")).append(provider_ID).toString());
				} else
				{
					response.sendRedirect("logistics/file/change_ok_a.jsp");
				}
				logistics_db.commit();
				logistics_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
